package com.bdqn.util;

import cn.hutool.core.date.DateUtil;
import cn.hutool.core.io.FileUtil;
import cn.hutool.core.io.IoUtil;
import cn.hutool.core.util.CharsetUtil;
import cn.hutool.core.util.StrUtil;
import com.bdqn.base.GlobalConstants;
import com.bdqn.pojo.ColumnEntity;
import com.bdqn.pojo.GenConfig;
import com.bdqn.pojo.TableEntity;
import lombok.experimental.UtilityClass;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.apache.commons.lang3.text.WordUtils;
import org.apache.velocity.Template;
import org.apache.velocity.VelocityContext;
import org.apache.velocity.app.Velocity;
import org.springframework.beans.factory.annotation.Value;

import java.io.File;
import java.io.IOException;
import java.io.StringWriter;
import java.util.*;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

/**
 * 代码生成器 工具类
 *
 * @author lilibo
 * @date 2019/2/1
 */
@Slf4j
@UtilityClass
public class GeneratorUtil {

	private static final String POM_XML_VM = "pom.xml.vm";
	private static final String ENTITY_JAVA_VM = "Entity.java.vm";
	private static final String MAPPER_JAVA_VM = "Mapper.java.vm";
	private static final String SERVICE_JAVA_VM = "Service.java.vm";
	private static final String SERVICE_IMPL_JAVA_VM = "ServiceImpl.java.vm";
	private static final String CONTROLLER_JAVA_VM = "Controller.java.vm";
	private static final String MAPPER_XML_VM = "Mapper.xml.vm";
	private static final String MENU_SQL_VM = "menu.sql.vm";
	private static final String INDEX_VUE_VM = "index.vue.vm";
	private static final String API_JS_VM = "api.js.vm";
	private static final String CRUD_JS_VM = "crud.js.vm";

	@Value("${qniao.codegen.mainPath}")
	private String S_MainPath = "com";
	@Value("${qniao.codegen.package}")
	private String S_Package = "com";
	@Value("${qniao.codegen.moduleName}")
	private String S_ModuleName = "bdqn";
	@Value("${qniao.codegen.tablePrefix}")
	private String S_TablePrefix = "";
	@Value("${qniao.codegen.author}")
	private String S_Author = "lilibo";

	private Map<String, String> getJdbcType() {
		Map<String, String> jdbcType= new HashMap<>();
		jdbcType.put("tinyint", "TINYINT");
		jdbcType.put("smallint", "SMALLINT");
		jdbcType.put("mediumint", "INTEGER");
		jdbcType.put("int", "INTEGER");
		jdbcType.put("integer", "INTEGER");
		jdbcType.put("bigint", "BIGINT");
		jdbcType.put("float", "FLOAT");
		jdbcType.put("double", "DOUBLE");
		jdbcType.put("decimal", "DECIMAL");
		jdbcType.put("bit", "BIT");
		jdbcType.put("boolean", "BOOLEAN");
		jdbcType.put("char", "CHAR");
		jdbcType.put("varchar", "VARCHAR");
		jdbcType.put("tinytext", "VARCHAR");
		jdbcType.put("text", "VARCHAR");
		jdbcType.put("mediumtext", "VARCHAR");
		jdbcType.put("longtext", "VARCHAR");
		jdbcType.put("date", "DATE");
		jdbcType.put("datetime", "TIME");
		jdbcType.put("timestamp", "TIMESTAMP");
		return jdbcType;
	}

	private Map<String, String> getJavaType() {
		Map<String, String> javaType= new HashMap<>();
		javaType.put("TINYINT", "Integer");
		javaType.put("SMALLINT", "Integer");
		javaType.put("INTEGER", "Integer");
		javaType.put("BIGINT", "Long");
		javaType.put("FLOAT", "Float");
		javaType.put("DOUBLE", "Double");
		javaType.put("DECIMAL", "BigDecimal");
		javaType.put("BIT", "Boolean");
		javaType.put("BOOLEAN", "Boolean");
		javaType.put("CHAR", "String");
		javaType.put("VARCHAR", "String");
		javaType.put("DATE", "String");
		javaType.put("TIME", "String");
		javaType.put("TIMESTAMP", "String");
		return javaType;
	}

	private List<String> getTemplates() {
		List<String> templates = new ArrayList<>();
		templates.add("template/Entity.java.vm");
		templates.add("template/Mapper.java.vm");
		templates.add("template/Mapper.xml.vm");
		templates.add("template/Service.java.vm");
		templates.add("template/ServiceImpl.java.vm");
		templates.add("template/Controller.java.vm");
		templates.add("template/menu.sql.vm");
		templates.add("template/index.vue.vm");
		templates.add("template/api.js.vm");
		templates.add("template/crud.js.vm");
		return templates;
	}

	/**
	 * 创建模块工程
	 */
	public void generatorProjectModule(GenConfig genConfig) {
		String projectPath = genConfig.getProjectPath();
		if (StrUtil.isNotBlank(projectPath)) {
			String[] paths = projectPath.split("[/]");
			genConfig.setProjectName(paths[paths.length-1]);
		} else {
			projectPath = System.getProperty(GlobalConstants.USER_DIR);
			genConfig.setProjectName(S_ModuleName);
		}
		String projectPom = projectPath + File.separator + "pom.xml";

		// 设置velocity资源加载器
		Properties prop = new Properties();
		prop.put("resource.loader.file.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader");
		Velocity.init(prop);
		// 封装模板数据
		Map<String, Object> map = new HashMap<>(16);
		map.put("date", DateUtil.format(DateUtil.date(), "yyyy/MM/dd"));
		if (StrUtil.isNotBlank(genConfig.getAuthor())) {
			map.put("author", genConfig.getAuthor());
		} else {
			map.put("author", S_Author);
		}
		if (StrUtil.isNotBlank(genConfig.getProjectName())) {
			map.put("projectName", genConfig.getProjectName());
		} else {
			map.put("projectName", S_ModuleName);
		}
		if (StrUtil.isNotBlank(genConfig.getModuleName())) {
			map.put("moduleName", genConfig.getModuleName());
		} else {
			map.put("moduleName", S_ModuleName);
		}
		if (StrUtil.isNotBlank(genConfig.getPackageName())) {
			map.put("package", genConfig.getPackageName());
			map.put("mainPath", genConfig.getPackageName());
		} else {
			map.put("package", S_Package);
			map.put("mainPath", S_MainPath);
		}
		VelocityContext context = new VelocityContext(map);

		// 获取模板列表
		String template = "template/" + POM_XML_VM;
		// 渲染模板
		StringWriter sw = new StringWriter();
		Template tpl = Velocity.getTemplate(template, CharsetUtil.UTF_8);
		tpl.merge(context, sw);
		// 将生成的文件写到目录
		FileUtil.writeBytes(sw.toString().getBytes(), projectPom);
	}

	/**
	 * 生成代码
	 */
	public void generatorCodeLocal(GenConfig genConfig, Map<String, String> table, List<Map<String, String>> columns) {
		// 配置信息
		boolean hasBigDecimal = false;
		// 表信息
		TableEntity tableEntity = new TableEntity();
		tableEntity.setTableName(table.get("tableName"));

		if (StrUtil.isNotBlank(genConfig.getComments())) {
			tableEntity.setComments(genConfig.getComments());
		} else {
			tableEntity.setComments(table.get("tableComment"));
		}

		String tablePrefix;
		if (StrUtil.isNotBlank(genConfig.getTablePrefix())) {
			tablePrefix = genConfig.getTablePrefix();
		} else {
			tablePrefix = S_TablePrefix;
		}

		// 表名转换成Java类名
		String className = tableToJava(tableEntity.getTableName(), tablePrefix);
		tableEntity.setCaseClassName(className);
		tableEntity.setLowerClassName(StringUtils.uncapitalize(className));

		// 列信息
		List<ColumnEntity> columnList = new ArrayList<>();
		for (Map<String, String> column : columns) {
			ColumnEntity columnEntity = new ColumnEntity();
			columnEntity.setColumnName(column.get("columnName"));
			columnEntity.setJdbcType(getJdbcType().get(column.get("dataType")));
			columnEntity.setComments(column.get("columnComment"));
			columnEntity.setExtra(column.get("extra"));

			// 列名转换成Java属性名
			String attrName = columnToJava(columnEntity.getColumnName());
			columnEntity.setCaseAttrName(attrName);
			columnEntity.setLowerAttrName(StringUtils.uncapitalize(attrName));

			// 列的数据类型，转换成Java类型
			String javaType = getJavaType().get(columnEntity.getJdbcType());
			columnEntity.setJavaType(javaType);
			if (!hasBigDecimal && "BigDecimal".equals(javaType)) {
				hasBigDecimal = true;
			}
			// 是否主键
			if ("PRI".equalsIgnoreCase(column.get("columnKey")) && tableEntity.getPk() == null) {
				tableEntity.setPk(columnEntity);
			}

			columnList.add(columnEntity);
		}
		tableEntity.setColumns(columnList);

		// 没主键，则第一个字段为主键
		if (tableEntity.getPk() == null) {
			tableEntity.setPk(tableEntity.getColumns().get(0));
		}

		// 设置velocity资源加载器
		Properties prop = new Properties();
		prop.put("resource.loader.file.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader");
		Velocity.init(prop);
		// 封装模板数据
		Map<String, Object> map = new HashMap<>(16);
		map.put("tableName", tableEntity.getTableName());
		map.put("pk", tableEntity.getPk());
		map.put("className", tableEntity.getCaseClassName());
		map.put("classname", tableEntity.getLowerClassName());
		map.put("pathName", tableEntity.getLowerClassName().toLowerCase());
		map.put("columns", tableEntity.getColumns());
		map.put("hasBigDecimal", hasBigDecimal);
		map.put("date", DateUtil.format(DateUtil.date(), "yyyy/MM/dd"));

		if (StrUtil.isNotBlank(genConfig.getComments())) {
			map.put("comments", genConfig.getComments());
		} else {
			map.put("comments", tableEntity.getComments());
		}

		if (StrUtil.isNotBlank(genConfig.getAuthor())) {
			map.put("author", genConfig.getAuthor());
		} else {
			map.put("author", S_Author);
		}

		if (StrUtil.isNotBlank(genConfig.getModuleName())) {
			map.put("moduleName", genConfig.getModuleName());
		} else {
			map.put("moduleName", S_ModuleName);
		}

		if (StrUtil.isNotBlank(genConfig.getPackageName())) {
			map.put("package", genConfig.getPackageName());
			map.put("mainPath", genConfig.getPackageName());
		} else {
			map.put("package", S_Package);
			map.put("mainPath", S_MainPath);
		}
		VelocityContext context = new VelocityContext(map);

		// 获取模板列表
		List<String> templates = getTemplates();
		for (String template : templates) {
			// 渲染模板
			StringWriter sw = new StringWriter();
			Template tpl = Velocity.getTemplate(template, CharsetUtil.UTF_8);
			tpl.merge(context, sw);
			// 将生成的文件写到目录
			String fileName = Objects.requireNonNull(getLocalFileName(genConfig.getProjectPath(), template, tableEntity.getCaseClassName(), map.get("package").toString(), map.get("moduleName").toString()));
			FileUtil.writeBytes(sw.toString().getBytes(), fileName);
		}
	}

	/**
	 * 生成代码
	 */
	public void generatorCode(GenConfig genConfig, Map<String, String> table, List<Map<String, String>> columns, ZipOutputStream zip) {
		// 配置信息
		boolean hasBigDecimal = false;
		// 表信息
		TableEntity tableEntity = new TableEntity();
		tableEntity.setTableName(table.get("tableName"));

		if (StrUtil.isNotBlank(genConfig.getComments())) {
			tableEntity.setComments(genConfig.getComments());
		} else {
			tableEntity.setComments(table.get("tableComment"));
		}

		String tablePrefix;
		if (StrUtil.isNotBlank(genConfig.getTablePrefix())) {
			tablePrefix = genConfig.getTablePrefix();
		} else {
			tablePrefix = S_TablePrefix;
		}

		// 表名转换成Java类名
		String className = tableToJava(tableEntity.getTableName(), tablePrefix);
		tableEntity.setCaseClassName(className);
		tableEntity.setLowerClassName(StringUtils.uncapitalize(className));

		// 列信息
		List<ColumnEntity> columnList = new ArrayList<>();
		for (Map<String, String> column : columns) {
			ColumnEntity columnEntity = new ColumnEntity();
			columnEntity.setColumnName(column.get("columnName"));
			columnEntity.setJdbcType(getJdbcType().get(column.get("dataType")));
			columnEntity.setComments(column.get("columnComment"));
			columnEntity.setExtra(column.get("extra"));

			// 列名转换成Java属性名
			String attrName = columnToJava(columnEntity.getColumnName());
			columnEntity.setCaseAttrName(attrName);
			columnEntity.setLowerAttrName(StringUtils.uncapitalize(attrName));

			// 列的数据类型，转换成Java类型
			String attrType = getJavaType().get(columnEntity.getJdbcType());
			columnEntity.setJavaType(attrType);
			if (!hasBigDecimal && "BigDecimal".equals(attrType)) {
				hasBigDecimal = true;
			}
			// 是否主键
			if ("PRI".equalsIgnoreCase(column.get("columnKey")) && tableEntity.getPk() == null) {
				tableEntity.setPk(columnEntity);
			}

			columnList.add(columnEntity);
		}
		tableEntity.setColumns(columnList);

		// 没主键，则第一个字段为主键
		if (tableEntity.getPk() == null) {
			tableEntity.setPk(tableEntity.getColumns().get(0));
		}

		// 设置velocity资源加载器
		Properties prop = new Properties();
		prop.put("resource.loader.file.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader");
		Velocity.init(prop);
		// 封装模板数据
		Map<String, Object> map = new HashMap<>(16);
		map.put("tableName", tableEntity.getTableName());
		map.put("pk", tableEntity.getPk());
		map.put("className", tableEntity.getCaseClassName());
		map.put("classname", tableEntity.getLowerClassName());
		map.put("pathName", tableEntity.getLowerClassName().toLowerCase());
		map.put("columns", tableEntity.getColumns());
		map.put("hasBigDecimal", hasBigDecimal);
		map.put("date", DateUtil.format(DateUtil.date(), "yyyy/MM/dd"));

		if (StrUtil.isNotBlank(genConfig.getComments())) {
			map.put("comments", genConfig.getComments());
		} else {
			map.put("comments", tableEntity.getComments());
		}

		if (StrUtil.isNotBlank(genConfig.getAuthor())) {
			map.put("author", genConfig.getAuthor());
		} else {
			map.put("author", S_Author);
		}

		if (StrUtil.isNotBlank(genConfig.getModuleName())) {
			map.put("moduleName", genConfig.getModuleName());
		} else {
			map.put("moduleName", S_ModuleName);
		}

		if (StrUtil.isNotBlank(genConfig.getPackageName())) {
			map.put("package", genConfig.getPackageName());
			map.put("mainPath", genConfig.getPackageName());
		} else {
			map.put("package", S_Package);
			map.put("mainPath", S_MainPath);
		}
		VelocityContext context = new VelocityContext(map);

		// 获取模板列表
		List<String> templates = getTemplates();
		for (String template : templates) {
			// 渲染模板
			StringWriter sw = new StringWriter();
			Template tpl = Velocity.getTemplate(template, CharsetUtil.UTF_8);
			tpl.merge(context, sw);

			try {
				// 添加到zip
				zip.putNextEntry(new ZipEntry(Objects.requireNonNull(getFileName(template, tableEntity.getCaseClassName(), map.get("package").toString(), map.get("moduleName").toString()))));
				IoUtil.write(zip, CharsetUtil.UTF_8, false, sw.toString());
				IoUtil.close(sw);
				zip.closeEntry();
			} catch (IOException e) {
				log.debug("渲染模板失败，表名：" + tableEntity.getTableName(), e);
			}
		}
	}

	/**
	 * 列名转换成Java属性名
	 */
	private String columnToJava(String columnName) {
		return WordUtils.capitalizeFully(columnName, new char[]{'_'}).replace("_", "");
	}

	/**
	 * 表名转换成Java类名
	 */
	private String tableToJava(String tableName, String tablePrefix) {
		if (StringUtils.isNotBlank(tablePrefix)) {
			tableName = tableName.replace(tablePrefix, "");
		}
		return columnToJava(tableName);
	}

	/**
	 * 获取文件名（通过IDE运行直接生成模块代码）
	 */
	private String getLocalFileName(String template, String className, String packageName, String moduleName) {
		return getLocalFileName(System.getProperty(GlobalConstants.USER_DIR), template, className, packageName, moduleName);
	}

	/**
	 * 获取文件名（通过IDE运行直接生成模块代码）
	 */
	private String getLocalFileName(String projectPath, String template, String className, String packageName, String moduleName) {
		projectPath = StringUtils.isBlank(projectPath) ? System.getProperty(GlobalConstants.USER_DIR) : projectPath;
		String packagePath = projectPath + File.separator + "src" + File.separator + "main" + File.separator + "java" + File.separator;
		String resourcesPath = projectPath + File.separator + "src" + File.separator + "main" + File.separator + "resources" + File.separator;
		if (StringUtils.isNotBlank(packageName)) {
			packagePath += packageName.replace(".", File.separator) + File.separator + moduleName + File.separator;
		}
		if (template.contains(ENTITY_JAVA_VM)) {
			return packagePath + "pojo" + File.separator + className + ".java";
		}
		if (template.contains(MAPPER_JAVA_VM)) {
			return packagePath + "mapper" + File.separator + className + "Mapper.java";
		}
		if (template.contains(SERVICE_JAVA_VM)) {
			return packagePath + "service" + File.separator + className + "Service.java";
		}
		if (template.contains(SERVICE_IMPL_JAVA_VM)) {
			return packagePath + "service" + File.separator + className + "ServiceImpl.java";
		}
		if (template.contains(CONTROLLER_JAVA_VM)) {
			return packagePath + "controller" + File.separator + className + "Controller.java";
		}
		if (template.contains(MAPPER_XML_VM)) {
			return resourcesPath + "mapper" + File.separator + className + "Mapper.xml";
		}
		if (template.contains(MENU_SQL_VM)) {
			return resourcesPath + GlobalConstants.FRONT_END_PROJECT + File.separator + className.toLowerCase() + "_menu.sql";
		}
		if (template.contains(INDEX_VUE_VM)) {
			return resourcesPath + GlobalConstants.FRONT_END_PROJECT + File.separator + "views" + File.separator + moduleName + File.separator + className.toLowerCase() + File.separator + "index.vue";
		}
		if (template.contains(API_JS_VM)) {
			return resourcesPath + GlobalConstants.FRONT_END_PROJECT + File.separator + "api" + File.separator + moduleName + File.separator + className.toLowerCase() + ".js";
		}
		if (template.contains(CRUD_JS_VM)) {
			return resourcesPath + GlobalConstants.FRONT_END_PROJECT + File.separator + "const" + File.separator + moduleName + File.separator + className.toLowerCase() + ".js";
		}
		return null;
	}

	/**
	 * 获取文件名（通过Web端生成代码压缩包下载）
	 */
	private String getFileName(String template, String className, String packageName, String moduleName) {
		String packagePath = GlobalConstants.BACK_END_PROJECT + File.separator + "src" + File.separator + "main" + File.separator + "java" + File.separator;
		if (StringUtils.isNotBlank(packageName)) {
			packagePath += packageName.replace(".", File.separator) + File.separator + moduleName + File.separator;
		}
		if (template.contains(ENTITY_JAVA_VM)) {
			return packagePath + "pojo" + File.separator + className + ".java";
		}
		if (template.contains(MAPPER_JAVA_VM)) {
			return packagePath + "mapper" + File.separator + className + "Mapper.java";
		}
		if (template.contains(SERVICE_JAVA_VM)) {
			return packagePath + "service" + File.separator + className + "Service.java";
		}
		if (template.contains(SERVICE_IMPL_JAVA_VM)) {
			return packagePath + "service" + File.separator + className + "ServiceImpl.java";
		}
		if (template.contains(CONTROLLER_JAVA_VM)) {
			return packagePath + "controller" + File.separator + className + "Controller.java";
		}
		if (template.contains(MAPPER_XML_VM)) {
			return GlobalConstants.BACK_END_PROJECT + File.separator + "src" + File.separator + "main" + File.separator + "resources" + File.separator + "mapper" + File.separator + className + "Mapper.xml";
		}
		if (template.contains(MENU_SQL_VM)) {
			return className.toLowerCase() + "_menu.sql";
		}
		if (template.contains(INDEX_VUE_VM)) {
			return GlobalConstants.FRONT_END_PROJECT + File.separator + "src" + File.separator + "views" + File.separator + moduleName + File.separator + className.toLowerCase() + File.separator + "index.vue";
		}
		if (template.contains(API_JS_VM)) {
			return GlobalConstants.FRONT_END_PROJECT + File.separator + "src" + File.separator + "api" + File.separator + moduleName + File.separator + className.toLowerCase() + ".js";
		}
		if (template.contains(CRUD_JS_VM)) {
			return GlobalConstants.FRONT_END_PROJECT + File.separator + "src" + File.separator + "const" + File.separator + "crud" + File.separator + moduleName + File.separator + className.toLowerCase() + ".js";
		}
		return null;
	}

}
